Skip Headers

Oracle® OLAP DML Reference 10g Release 2 (10.2) Part Number B14346-01 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# MOVE

The MOVE command moves an object name to a new position in the NAME dimension of a workspace. The reorganizing effect of the MOVE command on the workspace is cosmetic. That is, no physical changes take place in workspace storage. Users often reorganize workspace objects so the output from DESCRIBE is easier to read.

Syntax

MOVE name... {FIRST|LAST|{BEFORE|AFTER} name2} [AW workspace]

Arguments

name...

  The names of one or more objects to move. You can specify the names individually, or use one of the following forms to specify a group of names:

    name TO name
    FIRST n
    LAST n
    boolean-expression (dimensioned by NAME)

  You can specify a qualified object name to indicate the attached workspace in which the object resides. As an alternative, you can use the AW argument to specify the workspace. Do not use both.

  When you do not use a qualified object name or the AW argument to specify a workspace, Oracle OLAP looks for the object in the current workspace.

FIRST
LAST

  The logical position in the NAME dimension to which Oracle OLAP moves the objects specified by the name argument. Specifying FIRST moves the objects to the beginning of the NAME dimension. Specifying LAST (the default) moves the names to the end of the NAME dimension.

BEFORE name2
AFTER name2

  The position before or after a particular object (name2) to which Oracle OLAP moves the objects specified by the name argument.

AW workspace

  The name of an attached workspace in which you wish to move the object. When you do not use a qualified object name or the AW argument to specify a workspace, objects are moved in the current workspace.

Notes

Alphabetizing Your Objects

You can arrange your workspace objects alphabetically with the following statements, which work on the NAME dimension.

    SORT NAME A NAME
    MOVE CHARLIST(NAME) FIRST

Examples

Example 18-8 Moving a Relation

This example shows how to move the relation `desc.product` after `product`. The OLAP DML statement

    SHOW CHARLIST(NAME)

produces the following list (annotation has been added).

    product           <--- Position of product
    district
    division
    line
    region
    marketlevel
    market
    month
    year
    quarter
    desc.product      <--- Old position of desc.product
    region.district
    division.product
    ...

The following statements

    MOVE desc.product AFTER product
    SHOW CHARLIST(NAME)

change the workspace order and produce the following list (annotation has been added).

    product           <--- Position of product
    desc.product      <--- New position of desc.product
    district
    division
    line
    region
    marketlevel
    market
    month
    year
    quarter
    region.district
    division.product
    ...